--房屋信息初始化
INSERT INTO house(file_code,hos_type) 
VALUES ('800843843', '1');
INSERT INTO house(file_code,hos_type) 
VALUES ('800843844', '1');
INSERT INTO house(file_code,hos_type) 
VALUES ('800843845', '1');
INSERT INTO house(file_code,hos_type) 
VALUES ('800843846', '1');
INSERT INTO house(file_code,hos_type,use_area) 
VALUES ('800843847', '0','552');
-- 出租信息初始化
INSERT INTO rent VALUES ('0', '800843843', '500', '200', 
'2011-02-21', null, '200', '何强','1');
INSERT INTO rent VALUES (RENT_SEQ_ID.NEXTVAL, '800843844', '1500', '1200', 
'2011-02-21', null, '1200', '何强1','1');
INSERT INTO rent VALUES (RENT_SEQ_ID.NEXTVAL, '800843845', '2500', '2200', 
'2011-02-21', null, '2200', '何强2','1');
INSERT INTO rent VALUES (RENT_SEQ_ID.NEXTVAL, '800843846', '3500', '3200', 
'2011-02-21', null, '3200', '何强3','1');
--缴费信息初始化
INSERT INTO PAYMENT VALUES(PAYMENT_SEQ_ID.NEXTVAL,0,'500',
'200','50','25',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2011-04-29',1,'admin');
INSERT INTO PAYMENT VALUES(PAYMENT_SEQ_ID.NEXTVAL,1,'1500',
'1200','150','125','333','1500','1200','150','125',
NULL,NULL,'2011-3-29',1,'admin');
INSERT INTO PAYMENT VALUES(PAYMENT_SEQ_ID.NEXTVAL,2,'2500',
'2200','250','225','333',NULL,NULL,NULL,NULL,
'5000','4400','2011-3-29',1,'admin');

--欠费信息初始化
INSERT INTO OWE VALUES(OWE_SEQ_ID.NEXTVAL,0,'1500',
'1200','150','125','333',NULL,'3308','2011-03-30');

--欠费状态初始化
INSERT INTO init_status VALUES('2011-03-31','2011-03-30');

--水电统一单价初始化
INSERT INTO WEDEFINE VALUES('3.5','8');

--水电本月费用信息初始化
INSERT INTO WEMONTH VALUES(WEMONTH_SEQ_ID.NEXTVAL,'3.5','2.5',
'50','0','2011-03-02','0');